Release 10.1A: OpenEdge Deployment:
Startup Command and Parameter Reference

Collation Table (-cpcoll)

Use Collation Table (-cpcoll) to identify a collation table that Progress uses with the code page in memory. The code page is specified by the Internal Code Page (-cpinternal) parameter.

Operating system and syntax	UNIX Windows	-cpcoll tablename
Use with	Maximum value	Minimum value	Single-user default	Multi-user default
Client Session, Database Server	–	–	Basic	Basic

tablename

The name of a collation table within the convmap.cp file, or the name of a collation in the International Components for Unicode (ICU) library.

Progress uses the collation rules that you specify to compare characters and sort records if a BY clause cannot be satisfied by an index. The collation rules specified with the -cpcoll parameter take precedence over the collation specified for any database Progress accesses during the session, except when Progress uses or modifies pre-existing indexes. When you update or rebuild a database’s indexes, Progress uses the collation rules originally defined for that database.

If you do not use -cpcoll, Progress uses the language collation rules defined for the first database on the command line. If you do not specify a database on the command line, Progress uses the collation rules with the name “basic.”

To retrieve the value of this startup parameter at runtime, use the SESSION system handle.

See OpenEdge Development: Internationalizing Applications for more information on collation tables.